How to: Format horizontal alignment.
Solution:
Select the worksheet, select 'Page Setup...' from the 'File' menu, click the 'Margins' tab, and select the 'Horizontally' check box in the 'Center on Page' group.
1) Select the worksheet.
2) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
3) Click 'Margins' tab.
4) Select the 'Horizontally' check box in the 'Center on Page' group.
5) Click 'OK'.
